Delivery Dataset EDA

Dataset statistics

Number of variables	11
Number of observations	40374
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.4 MiB
Average record size in memory	88.0 B

Variable types

Numeric	7
Text	2
Categorical	1
DateTime	1

Alerts

`patient_id` has unique values	Unique
`usefulCount` has 2185 (5.4%) zeros	Zeros

Reproduction

Analysis started	2024-10-07 11:39:53.067065
Analysis finished	2024-10-07 11:40:13.920665
Duration	20.85 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

df_index
Real number (ℝ)

Distinct	9941
Distinct (%)	24.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4951.7208

Minimum	0
Maximum	9999
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	315.6 KiB

Quantile statistics

Minimum	0
5-th percentile	459
Q1	2432
median	4926.5
Q3	7478
95-th percentile	9487.35
Maximum	9999
Range	9999
Interquartile range (IQR)	5046

Descriptive statistics

Standard deviation	2903.0755
Coefficient of variation (CV)	0.58627608
Kurtosis	-1.2061536
Mean	4951.7208
Median Absolute Deviation (MAD)	2522.5
Skewness	0.014328404
Sum	1.9992078 × 10⁸
Variance	8427847.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1912	10	< 0.1%
3748	10	< 0.1%
7672	9	< 0.1%
9898	9	< 0.1%
9266	9	< 0.1%
8310	9	< 0.1%
402	9	< 0.1%
1410	9	< 0.1%
5549	9	< 0.1%
4612	9	< 0.1%
Other values (9931)	40282	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	6	< 0.1%
2	7	< 0.1%
3	5	< 0.1%
4	1	< 0.1%
5	5	< 0.1%
6	6	< 0.1%
7	4	< 0.1%
8	6	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
9999	5	< 0.1%
9998	7	< 0.1%
9997	8	< 0.1%
9996	4	< 0.1%
9995	5	< 0.1%
9994	6	< 0.1%
9993	3	< 0.1%
9992	4	< 0.1%
9991	5	< 0.1%
9990	2	< 0.1%

patient_id
Real number (ℝ)

UNIQUE

Distinct	40374
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	119859.19

Minimum	4
Maximum	232225
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	315.6 KiB

Quantile statistics

Minimum	4
5-th percentile	16057.65
Q1	68247.25
median	121926
Q3	170138
95-th percentile	225278.05
Maximum	232225
Range	232221
Interquartile range (IQR)	101890.75

Descriptive statistics

Standard deviation	64031.27
Coefficient of variation (CV)	0.53422077
Kurtosis	-1.0402521
Mean	119859.19
Median Absolute Deviation (MAD)	50309
Skewness	-0.0060764011
Sum	4.8391951 × 10⁹
Variance	4.1000036 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
143975	1	< 0.1%
136915	1	< 0.1%
99463	1	< 0.1%
76597	1	< 0.1%
192533	1	< 0.1%
201062	1	< 0.1%
72299	1	< 0.1%
106639	1	< 0.1%
151484	1	< 0.1%
214353	1	< 0.1%
Other values (40364)	40364	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
12	1	< 0.1%
14	1	< 0.1%
16	1	< 0.1%
22	1	< 0.1%

Value	Count	Frequency (%)
232225	1	< 0.1%
232224	1	< 0.1%
232223	1	< 0.1%
232220	1	< 0.1%
232218	1	< 0.1%
232217	1	< 0.1%
232215	1	< 0.1%
232213	1	< 0.1%
232210	1	< 0.1%
232208	1	< 0.1%

drugName
Text

Distinct	59
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	315.6 KiB

Length

Max length	54
Median length	31
Mean length	14.606578
Min length	5

Characters and Unicode

Total characters	589726
Distinct characters	47
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Etonogestrel
2nd row	Implanon
3rd row	Suprep Bowel Prep Kit
4th row	Escitalopram
5th row	Mirena

Value	Count	Frequency (%)
	7899	11.8%
ethinyl	6258	9.4%
estradiol	6258	9.4%
levonorgestrel	4158	6.2%
etonogestrel	3075	4.6%
norethindrone	2002	3.0%
nexplanon	1669	2.5%
norgestimate	1501	2.2%
sulfate	1431	2.1%
bupropion	1395	2.1%
Other values (59)	31125	46.6%

Most occurring characters

Value	Count	Frequency (%)
e	70544	12.0%
o	54876	9.3%
n	49849	8.5%
r	45787	7.8%
t	45748	7.8%
i	41047	7.0%
l	39366	6.7%
a	35974	6.1%
	26397	4.5%
s	23742	4.0%
Other values (37)	156396	26.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	589726	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	70544	12.0%
o	54876	9.3%
n	49849	8.5%
r	45787	7.8%
t	45748	7.8%
i	41047	7.0%
l	39366	6.7%
a	35974	6.1%
	26397	4.5%
s	23742	4.0%
Other values (37)	156396	26.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	589726	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	70544	12.0%
o	54876	9.3%
n	49849	8.5%
r	45787	7.8%
t	45748	7.8%
i	41047	7.0%
l	39366	6.7%
a	35974	6.1%
	26397	4.5%
s	23742	4.0%
Other values (37)	156396	26.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	589726	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	70544	12.0%
o	54876	9.3%
n	49849	8.5%
r	45787	7.8%
t	45748	7.8%
i	41047	7.0%
l	39366	6.7%
a	35974	6.1%
	26397	4.5%
s	23742	4.0%
Other values (37)	156396	26.5%

condition
Categorical

Distinct	41
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	315.6 KiB

birth control	16191
depression	4002
anxiety	2006
weight loss	1974
obesity	1772
Other values (36)	14429

Length

Max length	28
Median length	27
Mean length	13.574058
Min length	4

Characters and Unicode

Total characters	548039
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	birth control
2nd row	birth control
3rd row	bowel preparation
4th row	depression
5th row	birth control

Common Values

Value	Count	Frequency (%)
birth control	16191	40.1%
depression	4002	9.9%
anxiety	2006	5.0%
weight loss	1974	4.9%
obesity	1772	4.4%
emergency contraception	1408	3.5%
vaginal yeast infection	1264	3.1%
abnormal uterine bleeding	1237	3.1%
smoking cessation	1134	2.8%
acne	1072	2.7%
Other values (31)	8314	20.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
birth	16191	21.7%
control	16191	21.7%
depression	4002	5.4%
anxiety	3510	4.7%
disorde	2836	3.8%
weight	1974	2.6%
loss	1974	2.6%
obesity	1772	2.4%
infection	1465	2.0%
emergency	1408	1.9%
Other values (50)	23416	31.3%

Most occurring characters

Value	Count	Frequency (%)
o	57318	10.5%
r	52337	9.5%
t	51982	9.5%
i	51675	9.4%
n	46914	8.6%
e	43925	8.0%
	34365	6.3%
s	27985	5.1%
c	26253	4.8%
l	25685	4.7%
Other values (18)	129600	23.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	548039	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	57318	10.5%
r	52337	9.5%
t	51982	9.5%
i	51675	9.4%
n	46914	8.6%
e	43925	8.0%
	34365	6.3%
s	27985	5.1%
c	26253	4.8%
l	25685	4.7%
Other values (18)	129600	23.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	548039	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	57318	10.5%
r	52337	9.5%
t	51982	9.5%
i	51675	9.4%
n	46914	8.6%
e	43925	8.0%
	34365	6.3%
s	27985	5.1%
c	26253	4.8%
l	25685	4.7%
Other values (18)	129600	23.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	548039	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	57318	10.5%
r	52337	9.5%
t	51982	9.5%
i	51675	9.4%
n	46914	8.6%
e	43925	8.0%
	34365	6.3%
s	27985	5.1%
c	26253	4.8%
l	25685	4.7%
Other values (18)	129600	23.6%

rating
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.8069054

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	315.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	8
Q3	10
95-th percentile	10
Maximum	10
Range	9
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.2706596
Coefficient of variation (CV)	0.48049141
Kurtosis	-1.0411849
Mean	6.8069054
Median Absolute Deviation (MAD)	2
Skewness	-0.6894669
Sum	274822
Variance	10.697214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	11411	28.3%
9	6923	17.1%
1	5376	13.3%
8	4768	11.8%
7	2508	6.2%
5	2342	5.8%
2	1981	4.9%
3	1933	4.8%
6	1665	4.1%
4	1467	3.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5376	13.3%
2	1981	4.9%
3	1933	4.8%
4	1467	3.6%
5	2342	5.8%
6	1665	4.1%
7	2508	6.2%
8	4768	11.8%
9	6923	17.1%
10	11411	28.3%

Value	Count	Frequency (%)
10	11411	28.3%
9	6923	17.1%
8	4768	11.8%
7	2508	6.2%
6	1665	4.1%
5	2342	5.8%
4	1467	3.6%
3	1933	4.8%
2	1981	4.9%
1	5376	13.3%

date
Date

Distinct	3446
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Memory size	315.6 KiB

Minimum	2008-02-25 00:00:00
Maximum	2017-12-12 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

usefulCount
Real number (ℝ)

ZEROS

Distinct	328
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.184376

Minimum	0
Maximum	1291
Zeros	2185
Zeros (%)	5.4%
Negative	0
Negative (%)	0.0%
Memory size	315.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	10
Q3	27
95-th percentile	89
Maximum	1291
Range	1291
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	38.562687
Coefficient of variation (CV)	1.6633049
Kurtosis	145.04823
Mean	23.184376
Median Absolute Deviation (MAD)	8
Skewness	7.4244198
Sum	936046
Variance	1487.0809
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	2403	6.0%
1	2305	5.7%
3	2242	5.6%
4	2240	5.5%
0	2185	5.4%
5	2083	5.2%
6	1824	4.5%
7	1592	3.9%
8	1373	3.4%
9	1202	3.0%
Other values (318)	20925	51.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2185	5.4%
1	2305	5.7%
2	2403	6.0%
3	2242	5.6%
4	2240	5.5%
5	2083	5.2%
6	1824	4.5%
7	1592	3.9%
8	1373	3.4%
9	1202	3.0%

Value	Count	Frequency (%)
1291	2	< 0.1%
1247	2	< 0.1%
949	1	< 0.1%
796	1	< 0.1%
693	1	< 0.1%
644	1	< 0.1%
621	1	< 0.1%
556	2	< 0.1%
526	1	< 0.1%
505	2	< 0.1%

review_length
Real number (ℝ)

Distinct	231
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	102.21288

Minimum	31
Maximum	1894
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	315.6 KiB

Quantile statistics

Minimum	31
5-th percentile	41
Q1	72
median	106
Q3	134
95-th percentile	148
Maximum	1894
Range	1863
Interquartile range (IQR)	62

Descriptive statistics

Standard deviation	38.919325
Coefficient of variation (CV)	0.3807673
Kurtosis	138.91524
Mean	102.21288
Median Absolute Deviation (MAD)	30
Skewness	3.7384973
Sum	4126743
Variance	1514.7138
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
137	684	1.7%
140	669	1.7%
142	650	1.6%
139	647	1.6%
141	627	1.6%
134	616	1.5%
143	605	1.5%
138	604	1.5%
135	594	1.5%
132	589	1.5%
Other values (221)	34089	84.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
31	194	0.5%
32	170	0.4%
33	160	0.4%
34	181	0.4%
35	180	0.4%
36	200	0.5%
37	200	0.5%
38	203	0.5%
39	216	0.5%
40	193	0.5%

Value	Count	Frequency (%)
1894	1	< 0.1%
1107	1	< 0.1%
1103	1	< 0.1%
765	1	< 0.1%
617	1	< 0.1%
566	1	< 0.1%
558	2	< 0.1%
554	1	< 0.1%
532	1	< 0.1%
490	1	< 0.1%

review
Text

Distinct	33929
Distinct (%)	84.0%
Missing	0
Missing (%)	0.0%
Memory size	315.6 KiB

Length

Max length	10433
Median length	751
Mean length	537.13437
Min length	134

Characters and Unicode

Total characters	21686263
Distinct characters	103
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27486 ?
Unique (%)	68.1%

Sample

1st row	"my experience has been somewhat mixed. i have been using implanon now for nearly 14 months and have decided to get it removed because i bleed every day, all day. i would occasionally stain my underwear and my sheets. it didn't start out that way, for the first month i didn't bleed at all, then i had an epic two week period, then everything was irregular, which has basically been my new norm, sadly. i decided to get rid of the implanon because of the endless bleeding. i should mention that the bleeding was usually pretty light, a bit more than spotting but not quite a period either. other than the endless bleeding, i've been pretty side effect free, except for minor acne. i didn't get pregnant on it, so yeah! but...blood, a lot of blood."
2nd row	"this is my second implanon would not recommend at all....first one was okay for the first 2 years until i started bleeding which never stopped when i woke in the morning i would stand up and be absolutely covered in blood it was that bad.....i lost 2 stone in weight my mood swings were all over the place and it affected my relationship. i was advised to have that one removed and another one inserted which i did which i'm into the second year now and it's starting all over again! the only good thing about this is the reliability that your not going to get pregnant if there's ever a chance that you can have a quick fumble in between periods!! it gets me so down i can be off in the morning and on again at night.....so frustrating"
3rd row	"my prep instructions were one 6oz bottle the evening before and one 6oz bottle the morning of the colonoscopy. both times were similar, started working within 20-25 minutes and lasted a couple hours. i mixed with sprite. the review that mentions salty grape cough syrup was spot on. the first bottle wasn't terrible, the second one almost made me puke. compared to other prep experiences i've heard outside of this site i think suprep is probably one of the easier ones, of course everyone reacts different."
4th row	"i felt a positive difference within the first week. i also have generalized anxiety and it seems to have helped with it as well. due to my epilepsy, i take the highest dosage that i can, which is 10mg. i feel better but i think 20 would work great."
5th row	"i have been on mirena for over a year now and have experienced some side effects. side effects to watch out for are severe mood swings, hair loss, depression, acne, dizziness, headaches, memory loss, and insomnia. "

Value	Count	Frequency (%)
i	241801	5.9%
and	131487	3.2%
the	124167	3.0%
to	95149	2.3%
it	90351	2.2%
my	88903	2.2%
a	85934	2.1%
for	58439	1.4%
was	56284	1.4%
have	52734	1.3%
Other values (37242)	3101497	75.2%

Most occurring characters

Value	Count	Frequency (%)
	4120883	19.0%
e	1959109	9.0%
t	1558629	7.2%
i	1403755	6.5%
a	1363661	6.3%
o	1239702	5.7%
n	1159102	5.3%
s	994051	4.6%
r	861274	4.0%
d	743783	3.4%
Other values (93)	6282314	29.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21686263	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	4120883	19.0%
e	1959109	9.0%
t	1558629	7.2%
i	1403755	6.5%
a	1363661	6.3%
o	1239702	5.7%
n	1159102	5.3%
s	994051	4.6%
r	861274	4.0%
d	743783	3.4%
Other values (93)	6282314	29.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21686263	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	4120883	19.0%
e	1959109	9.0%
t	1558629	7.2%
i	1403755	6.5%
a	1363661	6.3%
o	1239702	5.7%
n	1159102	5.3%
s	994051	4.6%
r	861274	4.0%
d	743783	3.4%
Other values (93)	6282314	29.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21686263	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	4120883	19.0%
e	1959109	9.0%
t	1558629	7.2%
i	1403755	6.5%
a	1363661	6.3%
o	1239702	5.7%
n	1159102	5.3%
s	994051	4.6%
r	861274	4.0%
d	743783	3.4%
Other values (93)	6282314	29.0%

year
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2014.5011

Minimum	2008
Maximum	2017
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	315.6 KiB

Quantile statistics

Minimum	2008
5-th percentile	2009
Q1	2013
median	2015
Q3	2016
95-th percentile	2017
Maximum	2017
Range	9
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.3713601
Coefficient of variation (CV)	0.0011771451
Kurtosis	0.053997461
Mean	2014.5011
Median Absolute Deviation (MAD)	1
Skewness	-1.0194117
Sum	81333468
Variance	5.6233485
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2016	10128	25.1%
2015	8333	20.6%
2017	7830	19.4%
2014	3079	7.6%
2013	2705	6.7%
2011	2465	6.1%
2012	2140	5.3%
2009	1609	4.0%
2010	1544	3.8%
2008	541	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2008	541	1.3%
2009	1609	4.0%
2010	1544	3.8%
2011	2465	6.1%
2012	2140	5.3%
2013	2705	6.7%
2014	3079	7.6%
2015	8333	20.6%
2016	10128	25.1%
2017	7830	19.4%

Value	Count	Frequency (%)
2017	7830	19.4%
2016	10128	25.1%
2015	8333	20.6%
2014	3079	7.6%
2013	2705	6.7%
2012	2140	5.3%
2011	2465	6.1%
2010	1544	3.8%
2009	1609	4.0%
2008	541	1.3%

sentiment
Real number (ℝ)

Distinct	18128
Distinct (%)	44.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.049360133

Minimum	-1
Maximum	1
Zeros	357
Zeros (%)	0.9%
Negative	14162
Negative (%)	35.1%
Memory size	315.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	-0.24401414
Q1	-0.047367694
median	0.055238095
Q3	0.15555556
95-th percentile	0.3203125
Maximum	1
Range	2
Interquartile range (IQR)	0.20292325

Descriptive statistics

Standard deviation	0.17886839
Coefficient of variation (CV)	3.6237421
Kurtosis	2.6139764
Mean	0.049360133
Median Absolute Deviation (MAD)	0.10139194
Skewness	-0.3366228
Sum	1992.866
Variance	0.0319939
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	357	0.9%
0.1	164	0.4%
0.25	154	0.4%
0.15	122	0.3%
0.125	117	0.3%
0.05	105	0.3%
0.1666666667	102	0.3%
0.2	102	0.3%
0.03333333333	98	0.2%
0.3	98	0.2%
Other values (18118)	38955	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	26	0.1%
-0.9765625	1	< 0.1%
-0.96875	1	< 0.1%
-0.9656612873	1	< 0.1%
-0.95	2	< 0.1%
-0.9375	1	< 0.1%
-0.91	1	< 0.1%
-0.9	1	< 0.1%
-0.85	1	< 0.1%
-0.85	4	< 0.1%

Value	Count	Frequency (%)
1	12	< 0.1%
0.925	1	< 0.1%
0.9	1	< 0.1%
0.890625	2	< 0.1%
0.875	1	< 0.1%
0.85	1	< 0.1%
0.8333333333	2	< 0.1%
0.8125	1	< 0.1%
0.805	1	< 0.1%
0.80078125	1	< 0.1%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	df_index	patient_id	drugName	condition	rating	date	usefulCount	review_length	review	year	sentiment
0	1	143975	Etonogestrel	birth control	7	7-Aug-16	4	136	"my experience has been somewhat mixed. i have been using implanon now for nearly 14 months and have decided to get it removed because i bleed every day, all day. i would occasionally stain my underwear and my sheets. it didn't start out that way, for the first month i didn't bleed at all, then i had an epic two week period, then everything was irregular, which has basically been my new norm, sadly. \r\r\n\r\r\ni decided to get rid of the implanon because of the endless bleeding. i should mention that the bleeding was usually pretty light, a bit more than spotting but not quite a period either. other than the endless bleeding, i've been pretty side effect free, except for minor acne.\r\r\n\r\r\ni didn't get pregnant on it, so yeah! but...blood, a lot of blood."	2016	0.110472
1	2	106473	Implanon	birth control	1	11-May-16	6	140	"this is my second implanon would not recommend at all....first one was okay for the first 2 years until i started bleeding which never stopped when i woke in the morning i would stand up and be absolutely covered in blood it was that bad.....i lost 2 stone in weight my mood swings were all over the place and it affected my relationship. i was advised to have that one removed and another one inserted which i did which i'm into the second year now and it's starting all over again! the only good thing about this is the reliability that your not going to get pregnant if there's ever a chance that you can have a quick fumble in between periods!! it gets me so down i can be off in the morning and on again at night.....so frustrating"	2016	0.162384
2	6	207442	Suprep Bowel Prep Kit	bowel preparation	8	5-Dec-16	18	86	"my prep instructions were one 6oz bottle the evening before and one 6oz bottle the morning of the colonoscopy. both times were similar, started working within 20-25 minutes and lasted a couple hours. i mixed with sprite. the review that mentions salty grape cough syrup was spot on. the first bottle wasn't terrible, the second one almost made me puke. compared to other prep experiences i've heard outside of this site i think suprep is probably one of the easier ones, of course everyone reacts different."	2016	-0.109375
3	8	140845	Escitalopram	depression	9	21-Apr-16	13	49	"i felt a positive difference within the first week. i also have generalized anxiety and it seems to have helped with it as well. due to my epilepsy, i take the highest dosage that i can, which is 10mg. i feel better but i think 20 would work great."	2016	0.330455
4	9	182520	Mirena	birth control	1	15-Jun-09	45	37	"i have been on mirena for over a year now and have experienced some side effects. side effects to watch out for are severe mood swings, hair loss, depression, acne, dizziness, headaches, memory loss, and insomnia. "	2009	0.800000
5	12	198830	Depo-Provera	abnormal uterine bleeding	2	28-Aug-16	15	64	"so i've had two shots so far\r\r\n my period has been heavy when i get it and i spot all month long. i've experienced depression in the past and it seems like it's gotten worse on the shot. i've actually attempted suicide since i've started the shot.my sex drive is crap and my mood swings are crazy. i don't recommend this shot to anyone"	2016	-0.155556
6	13	45707	Fluoxetine	depression	1	17-Apr-12	17	84	"i took prozac for about five months 1989-90. i felt buoyant for the first six weeks, then less so. after three months or so, my mood was down and my fingers were stiff and painful upon waking. after four months, both hands and feet were in pain and did not function for an hour after waking. the condition persisted, in an ever-diminishing form, for five years after discontinuation of the medicine. i am told that my reaction was rare; nevertheless, it happened to me."	2012	-0.114418
7	18	148611	Mirena	birth control	10	8-Feb-17	40	134	"i love my iud for many reasons. a lot of these reviews are just based off of the initial side effects and insertion. while i admit it was mildly painful for the first 24 hours and the spotting lasted 1-2 months, i am now 3 years in, and couldn't be happier. my period is 95% lighter and lasts only an hour, i never get cramps anymore, and i am comforted by the fact that it is so reliable! no weight gain or mood changes and my skin is still clear. some people say these cause infertility but that is not true. iuds have undergone many many clinical studies which show that is not the case! don't let people on here scare you :) if you want the facts, go to a credible source. http://www.sciencedirect.com/science/article/pii/0010782485900484"	2017	0.208333
8	20	208115	Suprep Bowel Prep Kit	bowel preparation	8	2-Jul-12	28	66	"not as bad as i was expecting. the taste is like salty cough syrup, but better than nyquil. the volume to drink wasn't insurmountable. and the effect of the wasn't violent. just know that anything you drink after ingesting the dose will be passed soon afterwards for about then next 4 hours. based on all the reviews of other methods, this seems to be the mildest."	2012	-0.225000
9	22	178269	Duloxetine	depression	8	6-Dec-09	48	126	"i take 60 mg of cymbalta for depression for the last 5 years and i've felt a noticeable difference in my mood (depression lifted). i used to cry all the time for any little thing, and now my emotions are in check, no more cry baby! there are a few side effects, including out-of-nowhere jerking. it doesn't happen much, but when it does, it's weird! this is a medicine you cannot miss. i have inadvertently missed a dose and was back to the weepies, to the sadness. before i tried cymbalta, i had tried many, many other antidepressants and they never had any effect on my depression. then there was cymbalta. thank goodness for this medicine. i can't imagine my life without it. what a blessing."	2009	-0.025000

	df_index	patient_id	drugName	condition	rating	date	usefulCount	review_length	review	year	sentiment
40364	773	124603	Skyla	birth control	9	14-Aug-15	6	138	"i got skyla 2 years ago (around $2000 total for 3 years) , and want to get another one the next summer (3 years limit). the insertion of course is never fun, no surgery of any form will be - but i was well enough to enjoy movies that night with friends. my periods have gotten lighter and it's effective in preventing pregnancy. the only grief i have received from the little iud was monthly cramps that i associate with 'my body trying to get rid of it' and sometimes it's so painful i have to curl on the floor, stay still, and sometimes whimper and cry. however, i'm a big girl and it's perhaps twice as painful as my normal menstrual cramping and i'd rather have that once a month than a child i'm not ready for."	2015	-0.106250
40365	775	54807	Bupropion / naltrexone	weight loss	1	22-Feb-17	15	129	"i've been on contrave for just over 8 weeks now. i never experienced any of the side effects. i also have not lost any weight. i don't feel any differently about food and can't say i feel any less hungry. i am so disappointed and frustrated. today i called contrave to ask about the scale down program. i learned it involves getting a free smart scale. you can keep the scale but after 90 days if you want to keep the "smart" function you have to pay for the service. i also told him that i had not lost any weight and he said this is an "adverse effect" and that he needs to report it as such?? a colleague of mine uses this product and has great success."	2017	-0.020304
40366	779	85830	Ethinyl estradiol / norgestimate	birth control	9	7-Nov-13	9	113	"i tried bcp in college, but they aggravated my migraines. at age 23, my neurologist said that because most of my migraines occurred just before my period, orthotricylen would work for me. my migraines got better, my already clear complexion become clearer, and my periods lightened. however, the first three months were tough. my breasts swelled from a 34c to a 34d+ (enough to buy a bigger bra), i was easily enraged, and i became a bit of a space cadet - but it all went away after the first 3 months. i also never got pregnant until after taking this pill. if you have migraines, talk to your neurologist about this pill."	2013	0.197778
40367	786	31213	Miconazole	vaginal yeast infection	1	17-Oct-16	19	129	"i need you to read my story, as it may one day save your vagina's life!\r\nlast night, whilst wiggle-itching my way through kroger, i decided to purchase miconazole 1.\r\ni made the deposit at 11pm and hit the hay. at 2am, my vagina spontaneously combusted! i tried to wipe/rinse/claw the satan sauce from my vag, to no avail! i even laid spread eagle and quivering in front of a fan . \r\ni finally found some vagisil cooling wipes around 5am, and subsequently passed out.\r\ntoday, my vagina is swollen 4x its natural size...i'm barely walking, but when i do, it's an awkward cowgirl shuffle. i had to use a personal day from work.\r\ni'm applying back to back vagisil treatments, but i'm raw...so incredibly sore, swollen, and raw!"	2016	0.091587
40368	788	167113	Levonorgestrel	birth control	7	8-Jun-16	0	132	"well i just got the skyla put in yesterday morning, so far i've been quite crampy but it's a little different than regular period cramps, it's like i can feel the iud in there and maybe it just needs to get situated but i feel like it's not sitting comfortably yet. during my appt. everything was fine although i read a bunch of reviews and psyched myself out, but the doctor explained the process to me and answered my questions. the whole application process was just crampy although one of the applicators opened prematurely right in my cervix which caused a little pain (my doctor said she hadn't ever seen that before) overall, don't let people with low pain tolerances affect your decision about getting skyla. just be prepared for cramps! :)"	2016	0.127282
40369	789	73634	Ethinyl estradiol / norethindrone	birth control	5	8-Jan-13	13	119	"my ob/gyn put me on this pill because i have ovarian cysts that rupture causing severe pain and he said the hormones would prevent that from happening. i've been on it for about 2 weeks or so now and my main problem with it is that i get a migrane almost every single day now and i feel nauseous every single day and it gets worse at night. i also experience strong food cravings and certain smells make me feel like puking or thinking about certain foods makes me feel sick to my stomach too. other than that, its great. i guess. i've never been on birth control before so i guess its doing what its supposed to. "	2013	0.044643
40370	792	165612	Levonorgestrel	emergency contraception	10	26-Apr-17	8	101	"i had sex for the first time on april 10th. we didn't use protection, it was kinda in the moment so we didn't think about it. he didn't cum inside of me but he had cum before earlier in the night. i was terrifed that i might have gotten pregnant from the precum. especially since i was supposed to be ovulating. i took a plan b 10 hours later. i got nausea, cramps, backaches, headaches, acne, the works. i thought i was pregnant but it was just the side effects. my period came a day late, i started today, april 26th."	2017	0.088095
40371	794	148683	Mirena	birth control	9	24-Sep-16	5	132	"switched from combination pill to mirena after 5 years on the pill. i'm 27 and have never been pregnant.\r\r\nthe insertion was. the worst thing i've ever experienced ! almost fainted. the following 8 hours i had really bad cramps (never really had them before), i'd say a 8/10. also threw up six times and got diarrhoea. strange! the following 5 days light spotting, then light period (as planned) for about a week. \r\r\nit's now been almost 8 weeks since insertion, got my second period which was very light compared to being on the pill. apart from the horrible insertion i'm very content with mirena, absolutely worth it! also much cheaper as my pill cost around $10 each month and the mirena only $70 for five years, perk of living in sweden."	2016	0.033284
40372	796	138772	Phentermine	weight loss	10	7-Sep-12	55	78	"after suffering from bulimia for many years and not being able to control my binge eating i started taking fastin. i only take 1 1/2 pills a day (i'm only 115 lbs and not looking for significant weight loss) and that is enough to help me fight my urge to stress eat. in fact when i was taking 2 pills a day i found myself forgetting to eat. i still feel a little jittery after taking them. "	2012	0.169643
40373	797	113023	Bisacodyl	constipation	4	21-Oct-16	12	94	"well i took this to help get the pipes moving when they hadn't for a few days on a camping trip. first night back at home and i took of them with a lot of water at 11:30 pm. within 2 hours the gi cramping started, and continued and got progressively worse, sweats, nausea. the pipes moving sound loud rumbles started at about 4 am and continued through about 5 pm. it was awful.. awful. colonoscopy prep was better. i don't think i'll use this product again. i would not reccomend this to anyone."	2016	-0.150000

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Missing values

Sample